/*
 Navicat Premium Data Transfer

 Source Server         : FPE工序交接
 Source Server Type    : SQL Server
 Source Server Version : 15002000
 Source Host           : 192.168.0.208:1433
 Source Catalog        : fpe_apply
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 15002000
 File Encoding         : 65001

 Date: 30/09/2022 09:27:30
*/


-- ----------------------------
-- Table structure for apply_family_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[apply_family_info]') AND type IN ('U'))
	DROP TABLE [dbo].[apply_family_info]
GO

CREATE TABLE [dbo].[apply_family_info] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [apply_info_id] int  NULL,
  [appellation] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [name] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [now_live] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [now_workplace] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [age] int  NULL
)
GO

ALTER TABLE [dbo].[apply_family_info] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'所属申请信息id',
'SCHEMA', N'dbo',
'TABLE', N'apply_family_info',
'COLUMN', N'apply_info_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'称谓',
'SCHEMA', N'dbo',
'TABLE', N'apply_family_info',
'COLUMN', N'appellation'
GO

EXEC sp_addextendedproperty
'MS_Description', N'姓名',
'SCHEMA', N'dbo',
'TABLE', N'apply_family_info',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'现居地',
'SCHEMA', N'dbo',
'TABLE', N'apply_family_info',
'COLUMN', N'now_live'
GO

EXEC sp_addextendedproperty
'MS_Description', N'现工作地',
'SCHEMA', N'dbo',
'TABLE', N'apply_family_info',
'COLUMN', N'now_workplace'
GO

EXEC sp_addextendedproperty
'MS_Description', N'年龄',
'SCHEMA', N'dbo',
'TABLE', N'apply_family_info',
'COLUMN', N'age'
GO


-- ----------------------------
-- Records of apply_family_info
-- ----------------------------
SET IDENTITY_INSERT [dbo].[apply_family_info] ON
GO

INSERT INTO [dbo].[apply_family_info] ([id], [apply_info_id], [appellation], [name], [now_live], [now_workplace], [age]) VALUES (N'1', N'3', N'爸爸', N'杨慧娴', N'东莞', N'华为', NULL)
GO

SET IDENTITY_INSERT [dbo].[apply_family_info] OFF
GO


-- ----------------------------
-- Table structure for apply_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[apply_info]') AND type IN ('U'))
	DROP TABLE [dbo].[apply_info]
GO

CREATE TABLE [dbo].[apply_info] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [intention_post] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [apply_user_name] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [sex] char(2) COLLATE Chinese_PRC_CI_AI  NULL,
  [birthday] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [height] float(53)  NULL,
  [native_place] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [speciality] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [hobby] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [education] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [graduation_school ] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [major] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [graduation_day] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [telephone] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [intended_city ] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [english_level] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [english_certificate] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [office_software] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [source] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [create_time] datetime DEFAULT (getdate()) NULL,
  [t_political] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL
)
GO

ALTER TABLE [dbo].[apply_info] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'意向岗位',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'intention_post'
GO

EXEC sp_addextendedproperty
'MS_Description', N'申请人姓名',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'apply_user_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'性别',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'sex'
GO

EXEC sp_addextendedproperty
'MS_Description', N'出生日期',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'birthday'
GO

EXEC sp_addextendedproperty
'MS_Description', N'身高（单位厘米）',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'height'
GO

EXEC sp_addextendedproperty
'MS_Description', N'籍贯',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'native_place'
GO

EXEC sp_addextendedproperty
'MS_Description', N'特长',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'speciality'
GO

EXEC sp_addextendedproperty
'MS_Description', N'爱好',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'hobby'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最高学历',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'education'
GO

EXEC sp_addextendedproperty
'MS_Description', N'毕业学校',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'graduation_school '
GO

EXEC sp_addextendedproperty
'MS_Description', N'专业',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'major'
GO

EXEC sp_addextendedproperty
'MS_Description', N'毕业时间',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'graduation_day'
GO

EXEC sp_addextendedproperty
'MS_Description', N'手机号(唯一性)',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'telephone'
GO

EXEC sp_addextendedproperty
'MS_Description', N'意向工作城市',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'intended_city '
GO

EXEC sp_addextendedproperty
'MS_Description', N'英语水平',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'english_level'
GO

EXEC sp_addextendedproperty
'MS_Description', N'英语证书',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'english_certificate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'擅长办公软件',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'office_software'
GO

EXEC sp_addextendedproperty
'MS_Description', N'招聘信息来源',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'source'
GO

EXEC sp_addextendedproperty
'MS_Description', N'填表日期',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'政治面貌',
'SCHEMA', N'dbo',
'TABLE', N'apply_info',
'COLUMN', N't_political'
GO


-- ----------------------------
-- Records of apply_info
-- ----------------------------
SET IDENTITY_INSERT [dbo].[apply_info] ON
GO

INSERT INTO [dbo].[apply_info] ([id], [intention_post], [apply_user_name], [sex], [birthday], [height], [native_place], [speciality], [hobby], [education], [graduation_school ], [major], [graduation_day], [telephone], [intended_city ], [english_level], [english_certificate], [office_software], [source], [create_time], [t_political]) VALUES (N'3', N'人力资源管培生', N'杨慧娴', N'女', N'2022-09-29', N'165', N'东莞', N'摄影', N'唱歌', N'大专', N'广州大学', N'人力资源管理', N'2022-09-29', N'18027089676', N'东莞', N'可用口语形式沟通', N'四级证书', N'Word,Excel,PPT,PS,H5', N'校就业办', N'2022-09-29 14:38:45.223', N'共青团员/中共党员')
GO

SET IDENTITY_INSERT [dbo].[apply_info] OFF
GO


-- ----------------------------
-- Table structure for apply_internship_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[apply_internship_info]') AND type IN ('U'))
	DROP TABLE [dbo].[apply_internship_info]
GO

CREATE TABLE [dbo].[apply_internship_info] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [apply_info_id] int  NULL,
  [start_time] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [end_time] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [company_name] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [post_name] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL
)
GO

ALTER TABLE [dbo].[apply_internship_info] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'所属申请信息id',
'SCHEMA', N'dbo',
'TABLE', N'apply_internship_info',
'COLUMN', N'apply_info_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'开始时间',
'SCHEMA', N'dbo',
'TABLE', N'apply_internship_info',
'COLUMN', N'start_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'结束时间',
'SCHEMA', N'dbo',
'TABLE', N'apply_internship_info',
'COLUMN', N'end_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'单位名称',
'SCHEMA', N'dbo',
'TABLE', N'apply_internship_info',
'COLUMN', N'company_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'岗位名称',
'SCHEMA', N'dbo',
'TABLE', N'apply_internship_info',
'COLUMN', N'post_name'
GO


-- ----------------------------
-- Records of apply_internship_info
-- ----------------------------
SET IDENTITY_INSERT [dbo].[apply_internship_info] ON
GO

SET IDENTITY_INSERT [dbo].[apply_internship_info] OFF
GO


-- ----------------------------
-- Table structure for apply_train_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[apply_train_info]') AND type IN ('U'))
	DROP TABLE [dbo].[apply_train_info]
GO

CREATE TABLE [dbo].[apply_train_info] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [apply_info_id] int  NULL,
  [train_time] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [train_info] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [obtain_certificate] char(1) COLLATE Chinese_PRC_CI_AI  NULL,
  [remarks] varchar(255) COLLATE Chinese_PRC_CI_AI DEFAULT ('无') NULL
)
GO

ALTER TABLE [dbo].[apply_train_info] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of apply_train_info
-- ----------------------------
SET IDENTITY_INSERT [dbo].[apply_train_info] ON
GO

SET IDENTITY_INSERT [dbo].[apply_train_info] OFF
GO


-- ----------------------------
-- Table structure for resume_info
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[resume_info]') AND type IN ('U'))
	DROP TABLE [dbo].[resume_info]
GO

CREATE TABLE [dbo].[resume_info] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [apply_user_name] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [user_tel] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [resume_path] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [intention_post] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [create_time] datetime DEFAULT (getdate()) NULL
)
GO

ALTER TABLE [dbo].[resume_info] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'申请人',
'SCHEMA', N'dbo',
'TABLE', N'resume_info',
'COLUMN', N'apply_user_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'手机号',
'SCHEMA', N'dbo',
'TABLE', N'resume_info',
'COLUMN', N'user_tel'
GO

EXEC sp_addextendedproperty
'MS_Description', N'简历附件地址',
'SCHEMA', N'dbo',
'TABLE', N'resume_info',
'COLUMN', N'resume_path'
GO

EXEC sp_addextendedproperty
'MS_Description', N'意向岗位',
'SCHEMA', N'dbo',
'TABLE', N'resume_info',
'COLUMN', N'intention_post'
GO


-- ----------------------------
-- Records of resume_info
-- ----------------------------
SET IDENTITY_INSERT [dbo].[resume_info] ON
GO

INSERT INTO [dbo].[resume_info] ([id], [apply_user_name], [user_tel], [resume_path], [intention_post], [create_time]) VALUES (N'1', N'杨慧娴', N'18027089676', N'杨慧娴-18027089676-简历附件.pdf', N'人力资源部管培生', N'2022-09-29 14:40:00.040')
GO

SET IDENTITY_INSERT [dbo].[resume_info] OFF
GO


-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_post]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_post]
GO

CREATE TABLE [dbo].[sys_post] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [post_name] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [post_status] char(1) COLLATE Chinese_PRC_CI_AI  NULL
)
GO

ALTER TABLE [dbo].[sys_post] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'岗位名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_post',
'COLUMN', N'post_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'岗位状态(0表示停止招聘，1表示在招)',
'SCHEMA', N'dbo',
'TABLE', N'sys_post',
'COLUMN', N'post_status'
GO


-- ----------------------------
-- Records of sys_post
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_post] ON
GO

SET IDENTITY_INSERT [dbo].[sys_post] OFF
GO


-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user]
GO

CREATE TABLE [dbo].[sys_user] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [user_name] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [login_name] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL,
  [password] varchar(255) COLLATE Chinese_PRC_CI_AI  NULL
)
GO

ALTER TABLE [dbo].[sys_user] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_user
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_user] ON
GO

INSERT INTO [dbo].[sys_user] ([id], [user_name], [login_name], [password]) VALUES (N'1', N'管理员', N'admin', N'administrator')
GO

SET IDENTITY_INSERT [dbo].[sys_user] OFF
GO


-- ----------------------------
-- Auto increment value for apply_family_info
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[apply_family_info]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table apply_family_info
-- ----------------------------
ALTER TABLE [dbo].[apply_family_info] ADD CONSTRAINT [PK__apply_fa__3213E83F9C221512] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for apply_info
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[apply_info]', RESEED, 3)
GO


-- ----------------------------
-- Primary Key structure for table apply_info
-- ----------------------------
ALTER TABLE [dbo].[apply_info] ADD CONSTRAINT [PK__apply_in__3213E83F4FDBEEE4] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for apply_internship_info
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[apply_internship_info]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table apply_internship_info
-- ----------------------------
ALTER TABLE [dbo].[apply_internship_info] ADD CONSTRAINT [PK__apply_in__3213E83F8F94D8E9] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for apply_train_info
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[apply_train_info]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table apply_train_info
-- ----------------------------
ALTER TABLE [dbo].[apply_train_info] ADD CONSTRAINT [PK__apply_tr__3213E83FEDEBC4E1] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for resume_info
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[resume_info]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table resume_info
-- ----------------------------
ALTER TABLE [dbo].[resume_info] ADD CONSTRAINT [PK__resume_i__3213E83F8DE0F128] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_post
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_post]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table sys_post
-- ----------------------------
ALTER TABLE [dbo].[sys_post] ADD CONSTRAINT [PK__sys_post__3213E83F80B56306] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_user
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_user]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table sys_user
-- ----------------------------
ALTER TABLE [dbo].[sys_user] ADD CONSTRAINT [PK__sys_user__3213E83FED8B0E6B] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

